﻿/******************************************************    
文件名:TableSteelnameDB.cs
版权  (c)  2010-11-23 淘渺圈圈工作室
作者:黄媛媛
创建日期:2010-12-05
维护人员:黄媛媛
维护日期:2010-12-05
文件功能描述:金属材料热处理网络学习平台_访问牌号相关数据表操作
******************************************************/
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using System.Configuration;
using System.Collections;
using System.Data;

namespace Mmht.DB
{
    public class TableSteelnameDB
    {
        operate op = new operate();

        private void DB()
        {
            string sql = @"select 
                            a.id as id,a.name as steel_name,a.steel_type as steel_type,
                            b.technics as heat_treating_technics,
                            b.remark as structure,
                            a.name_en as steel_name_en,
                            a.remark as usefulness
                            from steel_composition a,heat_treating_data b
                            where a.name=b.name";
        }

        public DataTable getSteelname()
        {
            string sql = @"select id,steel_name,steel_type,heat_treating_technics,
                           structure,steel_name_en,usefulness from steelname";
            DataTable dt = new DataTable();
            dt = op.Query(sql);
            return dt;
        }

    }
}
